package App.Repository.impl;

import App.Model.Project.CrmProjectStageRelate;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;
import java.util.Set;

public interface CrmProjectStageRelateDao extends JpaRepository<CrmProjectStageRelate,String> {
    @Query(value = " select recid,stageid,projectid,stagestatus,completedtime,createtime, recorder " +
            " from crm_project_stage_relate " +
            " where recstatus=1 " +
            " and  projectid in (?1) ",nativeQuery = true)
    List<CrmProjectStageRelate> findByProjectId(Set<String> projectIds);
}
